Setting Trigger Properties

Use the Trigger Name edit box to set the trigger name.

Use the Fires dropdown list to define the trigger action time.

AFTER
Specify that the DML trigger is fired only when all operations specified in the triggering SQL statement have executed successfully.

INSTEAD OF
Specify that the DML trigger is executed instead of the triggering SQL statement, therefore, overriding the actions of the triggering statements.

Delete
The trigger is activated whenever a row is deleted from the table.

Insert
The trigger is activated whenever a new row is inserted into the table.

Update
The trigger is activated whenever a row is modified.

The Body tab defines the statement to execute when the trigger activates. To include your statement, just simply click to write. If you want to execute multiple statements, use the BEGIN ... END compound statement construct.

Advanced

Execute as
Specify the security context under which the trigger is executed.

Note: Support from SQL Server 2005 or later and SQL Azure.

User
Choose a user that the trigger executes in.

Note: Support from SQL Server 2005 or later and SQL Azure.

Definition Type
Choose the type of definition.

Note: Support from SQL Server 2005 or later.

Options

Encrypted
Obfuscate the text of the CREATE TRIGGER statement.

Note: Support from SQL Server 2005 or later.

Not for replication
Indicate that the trigger should not be executed when a replication agent modifies the table that is involved in the trigger.

Note: SQL Azure does not support.

Append
Specify that an additional trigger of an existing type should be added.

Note: SQL Azure does not support.

Comment
Specify the comment of the trigger.

Note: SQL Azure does not support.